home *** CD-ROM | disk | FTP | other *** search
/ Developer Source 7 / developer source - volume 7.iso / orinf / feb97 / aronf108.gif < prev    next >
Graphics Interchange Format  |  1997-06-27  |  33KB  |  354x316  |  4-bit (16 colors)
Labels: text | screenshot | display | number | line | parallel | font
OCR: select /*+ rule */ company name from company, sa es (here company compeny_Id = seres.company_id : sales period_id = 3 sd'es.salas_total > 1000 Execute Explain User |scott Close ASonct Stetomert Nested Loops Tablo Access Bu Rowe Soot company - Rows 358 Tablespece Users 2= Chique Index Unique Scan Scot company_ps (Compe y_id) - Distinct Keys: 356. Rons Per Key: t Tablespace :Users Figure 8: A sample SELECT statement and the accompanying explain plan, showing NESTED LOOPS.